Yelp is becoming a growing platform for digital marketing. In our current day and age, having a effective digital presence on the internet can be vital to the success of a business. Through the Yelp Dataset, we hope to be able to discover insights that will help a new business be successful in their environment. For this project, we will be specifically focusing on the city of Las Vegas and the Yelp data involved. The source of our data is Yelp Data Set.
The total number of restaurants reviewed on Yelp for Las Vegas is 18153. 255628 people tipped in Las Vegas and North Las Vegas. The average star rating of the restaurants in Las Vegas and North Las Vegas is 3.6754531. The most reviewed restaurant was Mon Ami Gabi. The summary data for price range(Min, 1st Quartile, Median, Mean, 3rd Quartile, Max, NA’s) is 1, 1, 2, 1.8098836, 2, 4, 6902.
The following summary table groups the data by star ratings and calculates the total number of checkins, tips and reviews. The star rating is arranged in ascending order. By arranging the data in this way we can know the summary about the various star-ratings.
| Rating | Checkins | Tips | Reviews |
|---|---|---|---|
| 1.0 | 1272 | 145 | 1397 |
| 1.5 | 12513 | 1373 | 8134 |
| 2.0 | 46172 | 4052 | 16332 |
| 2.5 | 188141 | 13528 | 53994 |
| 3.0 | 511429 | 33775 | 122801 |
| 3.5 | 1025875 | 72697 | 241564 |
| 4.0 | 1197592 | 87745 | 323649 |
| 4.5 | 476721 | 36549 | 152025 |
| 5.0 | 63995 | 5764 | 39800 |
The most number of checkins, tips, and reviews were at restaurants with rating 4.0. This means people reviews on Yelp mostly if they find the place is worth a 4.0 rating.
Above is a bar chart of the different price levels for businesses in the Las Vegas region. We included this to show prospective business owners on what the most common price level is for businesses in the area. This bar graph demonstrates that a majority of restaurants were in the $11-$30 range.
We wanted to find the correlation of people that were checking into the business and see if they were also leaving a review. We found that a majority of the people that checked in did not end up leaving a review. We wanted to include this to allow prospective businesses to see if running check-in promotions would increase the amount of positive reviews on their Yelp profile.